Pandas Profiling Report

Dataset statistics

Number of variables	15
Number of observations	87
Missing cells	78
Missing cells (%)	6.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	10.3 KiB
Average record size in memory	121.5 B

Variable types

Numeric	14
Categorical	1

Alerts

`Results` is highly correlated with `Reach` and 3 other fields	High correlation
`Reach` is highly correlated with `Results` and 5 other fields	High correlation
`Impressions` is highly correlated with `Results` and 5 other fields	High correlation
`Cost per results` is highly correlated with `Results` and 1 other fields	High correlation
`Amount spent (MXN)` is highly correlated with `Reach` and 5 other fields	High correlation
`Result rate` is highly correlated with `Results` and 1 other fields	High correlation
`New messaging connections` is highly correlated with `Reach` and 3 other fields	High correlation
`Messaging Conversations Started` is highly correlated with `Reach` and 3 other fields	High correlation
`Frequency` is highly correlated with `Reach` and 2 other fields	High correlation
`CPC (All) (MXN)` is highly correlated with `Amount spent (MXN)`	High correlation
`Results` is highly correlated with `Result rate`	High correlation
`Reach` is highly correlated with `Impressions` and 3 other fields	High correlation
`Impressions` is highly correlated with `Reach` and 3 other fields	High correlation
`Amount spent (MXN)` is highly correlated with `Reach` and 2 other fields	High correlation
`Result rate` is highly correlated with `Results`	High correlation
`New messaging connections` is highly correlated with `Reach` and 3 other fields	High correlation
`Messaging Conversations Started` is highly correlated with `Reach` and 2 other fields	High correlation
`Results` is highly correlated with `Messaging Conversations Started`	High correlation
`Reach` is highly correlated with `Impressions` and 3 other fields	High correlation
`Impressions` is highly correlated with `Reach` and 3 other fields	High correlation
`Cost per results` is highly correlated with `Result rate`	High correlation
`Amount spent (MXN)` is highly correlated with `Reach` and 4 other fields	High correlation
`Result rate` is highly correlated with `Cost per results`	High correlation
`New messaging connections` is highly correlated with `Reach` and 3 other fields	High correlation
`Messaging Conversations Started` is highly correlated with `Results` and 4 other fields	High correlation
`Frequency` is highly correlated with `Amount spent (MXN)`	High correlation
`Starts` is highly correlated with `Ends` and 1 other fields	High correlation
`Ends` is highly correlated with `Starts`	High correlation
`Ad set budget` is highly correlated with `Result rate` and 3 other fields	High correlation
`Results` is highly correlated with `Reach` and 2 other fields	High correlation
`Reach` is highly correlated with `Results` and 5 other fields	High correlation
`Impressions` is highly correlated with `Results` and 4 other fields	High correlation
`Cost per results` is highly correlated with `CPC (All) (MXN)`	High correlation
`Amount spent (MXN)` is highly correlated with `Starts` and 4 other fields	High correlation
`Result rate` is highly correlated with `Ad set budget` and 2 other fields	High correlation
`New messaging connections` is highly correlated with `Reach` and 3 other fields	High correlation
`Messaging Conversations Started` is highly correlated with `Ad set budget` and 4 other fields	High correlation
`Frequency` is highly correlated with `Result rate`	High correlation
`CPC (All) (MXN)` is highly correlated with `Ad set budget` and 1 other fields	High correlation
`CTR (all)` is highly correlated with `Ad set budget` and 1 other fields	High correlation
`Results` has 12 (13.8%) missing values	Missing
`Cost per results` has 12 (13.8%) missing values	Missing
`Result rate` has 13 (14.9%) missing values	Missing
`New messaging connections` has 23 (26.4%) missing values	Missing
`Messaging Conversations Started` has 18 (20.7%) missing values	Missing
`Reach` has 8 (9.2%) zeros	Zeros
`Impressions` has 8 (9.2%) zeros	Zeros
`Cost per results` has 1 (1.1%) zeros	Zeros
`Amount spent (MXN)` has 8 (9.2%) zeros	Zeros
`Frequency` has 8 (9.2%) zeros	Zeros
`CPC (All) (MXN)` has 9 (10.3%) zeros	Zeros
`CTR (all)` has 9 (10.3%) zeros	Zeros

Reproduction

Analysis started	2022-04-20 02:39:42.627034
Analysis finished	2022-04-20 02:40:01.301588
Duration	18.67 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

Campaign ID
Real number (ℝ_≥0)

Distinct	82
Distinct (%)	94.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	546.4022989

Minimum	121
Maximum	997
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	824.0 B

Quantile statistics

Minimum	121
5-th percentile	132.6
Q1	289
median	544
Q3	798.5
95-th percentile	963.4
Maximum	997
Range	876
Interquartile range (IQR)	509.5

Descriptive statistics

Standard deviation	275.7441289
Coefficient of variation (CV)	0.5046540425
Kurtosis	-1.252728351
Mean	546.4022989
Median Absolute Deviation (MAD)	262
Skewness	0.02785109742
Sum	47537
Variance	76034.82465
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
440	2	2.3%
995	2	2.3%
182	2	2.3%
465	2	2.3%
126	2	2.3%
341	1	1.1%
791	1	1.1%
907	1	1.1%
919	1	1.1%
248	1	1.1%
Other values (72)	72	82.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
121	1	1.1%
126	2	2.3%
127	1	1.1%
132	1	1.1%
134	1	1.1%
135	1	1.1%
144	1	1.1%
154	1	1.1%
175	1	1.1%
182	2	2.3%

Value	Count	Frequency (%)
997	1	1.1%
995	2	2.3%
968	1	1.1%
964	1	1.1%
962	1	1.1%
956	1	1.1%
938	1	1.1%
928	1	1.1%
921	1	1.1%
919	1	1.1%

Starts
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	11
Distinct (%)	12.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.459770115

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	824.0 B

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	10
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	4.105596288
Coefficient of variation (CV)	0.7519723727
Kurtosis	-1.45208762
Mean	5.459770115
Median Absolute Deviation (MAD)	3
Skewness	0.4478453355
Sum	475
Variance	16.85592088
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
1	17	19.5%
2	15	17.2%
11	14	16.1%
3	11	12.6%
6	8	9.2%
12	7	8.0%
5	6	6.9%
10	5	5.7%
9	2	2.3%
4	1	1.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	17	19.5%
2	15	17.2%
3	11	12.6%
4	1	1.1%
5	6	6.9%
6	8	9.2%
7	1	1.1%
9	2	2.3%
10	5	5.7%
11	14	16.1%

Value	Count	Frequency (%)
12	7	8.0%
11	14	16.1%
10	5	5.7%
9	2	2.3%
7	1	1.1%
6	8	9.2%
5	6	6.9%
4	1	1.1%
3	11	12.6%
2	15	17.2%

Ends
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	10
Distinct (%)	11.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.701149425

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	824.0 B

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	10
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	3.997426331
Coefficient of variation (CV)	0.7011614733
Kurtosis	-1.465909544
Mean	5.701149425
Median Absolute Deviation (MAD)	2
Skewness	0.4431426903
Sum	496
Variance	15.97941727
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2	20	23.0%
3	13	14.9%
11	13	14.9%
12	8	9.2%
1	8	9.2%
6	7	8.0%
10	7	8.0%
5	5	5.7%
4	3	3.4%
7	3	3.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	8	9.2%
2	20	23.0%
3	13	14.9%
4	3	3.4%
5	5	5.7%
6	7	8.0%
7	3	3.4%
10	7	8.0%
11	13	14.9%
12	8	9.2%

Value	Count	Frequency (%)
12	8	9.2%
11	13	14.9%
10	7	8.0%
7	3	3.4%
6	7	8.0%
5	5	5.7%
4	3	3.4%
3	13	14.9%
2	20	23.0%
1	8	9.2%

Ad set budget
Categorical

HIGH CORRELATION

Distinct	21
Distinct (%)	24.1%
Missing	0
Missing (%)	0.0%
Memory size	824.0 B

Using ad set budget	29
500	10
300	10
1000	7
200	5
Other values (16)	26

Length

Max length	19
Median length	4
Mean length	8.540229885
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	8 ?
Unique (%)	9.2%

Sample

1st row	Using ad set budget
2nd row	Using ad set budget
3rd row	Using ad set budget
4th row	Using ad set budget
5th row	Using ad set budget

Common Values

Value	Count	Frequency (%)
Using ad set budget	29	33.3%
500	10	11.5%
300	10	11.5%
1000	7	8.0%
200	5	5.7%
350	3	3.4%
2000	3	3.4%
1500	2	2.3%
100	2	2.3%
400	2	2.3%
Other values (11)	14	16.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
using	29	16.7%
set	29	16.7%
budget	29	16.7%
ad	29	16.7%
500	10	5.7%
300	10	5.7%
1000	7	4.0%
200	5	2.9%
350	3	1.7%
2000	3	1.7%
Other values (14)	20	11.5%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Results
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	46
Distinct (%)	61.3%
Missing	12
Missing (%)	13.8%
Infinite	0
Infinite (%)	0.0%
Mean	387.76

Minimum	1
Maximum	16326
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	824.0 B

Quantile statistics

Minimum	1
5-th percentile	1
Q1	6
median	17
Q3	43
95-th percentile	1316.6
Maximum	16326
Range	16325
Interquartile range (IQR)	37

Descriptive statistics

Standard deviation	1944.376325
Coefficient of variation (CV)	5.014380867
Kurtosis	63.18845889
Mean	387.76
Median Absolute Deviation (MAD)	14
Skewness	7.730455776
Sum	29082
Variance	3780599.293
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=46)

Value	Count	Frequency (%)
1	5	5.7%
3	4	4.6%
10	4	4.6%
8	4	4.6%
5	3	3.4%
2	3	3.4%
9	3	3.4%
6	3	3.4%
17	3	3.4%
43	2	2.3%
Other values (36)	41	47.1%
(Missing)	12	13.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	5	5.7%
2	3	3.4%
3	4	4.6%
4	2	2.3%
5	3	3.4%
6	3	3.4%
7	1	1.1%
8	4	4.6%
9	3	3.4%
10	4	4.6%

Value	Count	Frequency (%)
16326	1	1.1%
3757	1	1.1%
2263	1	1.1%
1661	1	1.1%
1169	1	1.1%
587	1	1.1%
505	1	1.1%
399	1	1.1%
295	1	1.1%
293	1	1.1%

Reach
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	80
Distinct (%)	92.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5641.367816

Minimum	0
Maximum	41768
Zeros	8
Zeros (%)	9.2%
Negative	0
Negative (%)	0.0%
Memory size	824.0 B

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1221
median	3657
Q3	7639.5
95-th percentile	17733.5
Maximum	41768
Range	41768
Interquartile range (IQR)	6418.5

Descriptive statistics

Standard deviation	6796.188388
Coefficient of variation (CV)	1.204705775
Kurtosis	9.236924449
Mean	5641.367816
Median Absolute Deviation (MAD)	2794
Skewness	2.557660414
Sum	490799
Variance	46188176.61
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	8	9.2%
2511	1	1.1%
5276	1	1.1%
2048	1	1.1%
4081	1	1.1%
1402	1	1.1%
2218	1	1.1%
8417	1	1.1%
4285	1	1.1%
42	1	1.1%
Other values (70)	70	80.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	8	9.2%
42	1	1.1%
191	1	1.1%
395	1	1.1%
523	1	1.1%
540	1	1.1%
620	1	1.1%
689	1	1.1%
700	1	1.1%
725	1	1.1%

Value	Count	Frequency (%)
41768	1	1.1%
25664	1	1.1%
23776	1	1.1%
20564	1	1.1%
17804	1	1.1%
17569	1	1.1%
14376	1	1.1%
13750	1	1.1%
13536	1	1.1%
13358	1	1.1%

Impressions
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	80
Distinct (%)	92.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7472.931034

Minimum	0
Maximum	55206
Zeros	8
Zeros (%)	9.2%
Negative	0
Negative (%)	0.0%
Memory size	824.0 B

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1514
median	4527
Q3	9533
95-th percentile	24923.9
Maximum	55206
Range	55206
Interquartile range (IQR)	8019

Descriptive statistics

Standard deviation	9174.974191
Coefficient of variation (CV)	1.227761122
Kurtosis	8.367787355
Mean	7472.931034
Median Absolute Deviation (MAD)	3650
Skewness	2.472016888
Sum	650145
Variance	84180151.41
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	8	9.2%
3072	1	1.1%
8177	1	1.1%
2902	1	1.1%
5283	1	1.1%
1537	1	1.1%
2825	1	1.1%
9937	1	1.1%
6092	1	1.1%
42	1	1.1%
Other values (70)	70	80.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	8	9.2%
42	1	1.1%
196	1	1.1%
395	1	1.1%
538	1	1.1%
634	1	1.1%
661	1	1.1%
715	1	1.1%
749	1	1.1%
993	1	1.1%

Value	Count	Frequency (%)
55206	1	1.1%
34067	1	1.1%
29535	1	1.1%
28250	1	1.1%
25364	1	1.1%
23897	1	1.1%
22806	1	1.1%
22243	1	1.1%
20019	1	1.1%
17851	1	1.1%

Cost per results
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
ZEROS

Distinct	74
Distinct (%)	98.7%
Missing	12
Missing (%)	13.8%
Infinite	0
Infinite (%)	0.0%
Mean	17.16460531

Minimum	0
Maximum	118.1957143
Zeros	1
Zeros (%)	1.1%
Negative	0
Negative (%)	0.0%
Memory size	824.0 B

Quantile statistics

Minimum	0
5-th percentile	0.0784661873
Q1	4.718406593
median	11.62790698
Q3	22.93363636
95-th percentile	59.94883333
Maximum	118.1957143
Range	118.1957143
Interquartile range (IQR)	18.21522977

Descriptive statistics

Standard deviation	19.57396203
Coefficient of variation (CV)	1.140367732
Kurtosis	9.672232912
Mean	17.16460531
Median Absolute Deviation (MAD)	8.686730509
Skewness	2.634775576
Sum	1287.345398
Variance	383.1399896
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16.66666667	2	2.3%
10.5025	1	1.1%
18.86875	1	1.1%
69.772	1	1.1%
3.125	1	1.1%
1.57	1	1.1%
6.302	1	1.1%
0.372344322	1	1.1%
8.8	1	1.1%
24.44444444	1	1.1%
Other values (64)	64	73.6%
(Missing)	12	13.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	1.1%
0.043549488	1	1.1%
0.049604925	1	1.1%
0.06195316	1	1.1%
0.085543199	1	1.1%
0.086252129	1	1.1%
0.092454086	1	1.1%
0.177405941	1	1.1%
0.200084287	1	1.1%
0.338983051	1	1.1%

Value	Count	Frequency (%)
118.1957143	1	1.1%
69.772	1	1.1%
66.7725	1	1.1%
65.55	1	1.1%
57.54833333	1	1.1%
39.04352941	1	1.1%
38.3975	1	1.1%
34.317	1	1.1%
32.02	1	1.1%
31.95	1	1.1%

Amount spent (MXN)
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	70
Distinct (%)	80.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	232.6009195

Minimum	0
Maximum	1000
Zeros	8
Zeros (%)	9.2%
Negative	0
Negative (%)	0.0%
Memory size	824.0 B

Quantile statistics

Minimum	0
5-th percentile	0
Q1	48.455
median	145.29
Q3	348.105
95-th percentile	786.208
Maximum	1000
Range	1000
Interquartile range (IQR)	299.65

Descriptive statistics

Standard deviation	242.1726101
Coefficient of variation (CV)	1.041150699
Kurtosis	1.009047938
Mean	232.6009195
Median Absolute Deviation (MAD)	122.33
Skewness	1.284634332
Sum	20236.28
Variance	58647.57307
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	8	9.2%
500	6	6.9%
100	4	4.6%
140.2	2	2.3%
380	2	2.3%
332.34	1	1.1%
270	1	1.1%
59.03	1	1.1%
17.6	1	1.1%
168.04	1	1.1%
Other values (60)	60	69.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	8	9.2%
1.57	1	1.1%
10.75	1	1.1%
12.76	1	1.1%
16.57	1	1.1%
17.6	1	1.1%
23.14	1	1.1%
26.49	1	1.1%
31.51	1	1.1%
31.95	1	1.1%

Value	Count	Frequency (%)
1000	1	1.1%
887.41	1	1.1%
827.37	1	1.1%
809.85	1	1.1%
787.3	1	1.1%
783.66	1	1.1%
663.74	1	1.1%
633.2	1	1.1%
607.57	1	1.1%
500	6	6.9%

Result rate
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	74
Distinct (%)	100.0%
Missing	13
Missing (%)	14.9%
Infinite	0
Infinite (%)	0.0%
Mean	4.137558289

Minimum	0.035078488
Maximum	74.17721519
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	824.0 B

Quantile statistics

Minimum	0.035078488
5-th percentile	0.081628135
Q1	0.1515175448
median	0.274435813
Q3	0.5872112327
95-th percentile	11.64044754
Maximum	74.17721519
Range	74.1421367
Interquartile range (IQR)	0.435693688

Descriptive statistics

Standard deviation	13.99209232
Coefficient of variation (CV)	3.381726936
Kurtosis	19.59746779
Mean	4.137558289
Median Absolute Deviation (MAD)	0.1382532515
Skewness	4.495280686
Sum	306.1793134
Variance	195.7786474
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.137835975	1	1.1%
0.130123617	1	1.1%
0.283185841	1	1.1%
0.050316997	1	1.1%
1.050558109	1	1.1%
2.380952381	1	1.1%
0.31075202	1	1.1%
5.229885057	1	1.1%
0.230083405	1	1.1%
0.267022697	1	1.1%
Other values (64)	64	73.6%
(Missing)	13	14.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.035078488	1	1.1%
0.050316997	1	1.1%
0.063492063	1	1.1%
0.068386088	1	1.1%
0.088758468	1	1.1%
0.092947601	1	1.1%
0.096153846	1	1.1%
0.110448421	1	1.1%
0.111028868	1	1.1%
0.114890854	1	1.1%

Value	Count	Frequency (%)
74.17721519	1	1.1%
71.58642463	1	1.1%
65.06612996	1	1.1%
12.77735272	1	1.1%
11.02826783	1	1.1%
11.01093802	1	1.1%
9.509152762	1	1.1%
7.460481607	1	1.1%
7.1863581	1	1.1%
5.229885057	1	1.1%

New messaging connections
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	27
Distinct (%)	42.2%
Missing	23
Missing (%)	26.4%
Infinite	0
Infinite (%)	0.0%
Mean	15.046875

Minimum	1
Maximum	116
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	824.0 B

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	8
Q3	22.25
95-th percentile	40
Maximum	116
Range	115
Interquartile range (IQR)	19.25

Descriptive statistics

Standard deviation	18.55017194
Coefficient of variation (CV)	1.232825549
Kurtosis	12.9834101
Mean	15.046875
Median Absolute Deviation (MAD)	6
Skewness	2.938898062
Sum	963
Variance	344.108879
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
1	8	9.2%
3	6	6.9%
2	6	6.9%
6	4	4.6%
9	3	3.4%
8	3	3.4%
10	3	3.4%
7	3	3.4%
40	3	3.4%
26	3	3.4%
Other values (17)	22	25.3%
(Missing)	23	26.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	8	9.2%
2	6	6.9%
3	6	6.9%
4	2	2.3%
5	1	1.1%
6	4	4.6%
7	3	3.4%
8	3	3.4%
9	3	3.4%
10	3	3.4%

Value	Count	Frequency (%)
116	1	1.1%
51	1	1.1%
48	1	1.1%
40	3	3.4%
39	1	1.1%
36	1	1.1%
33	1	1.1%
32	1	1.1%
29	1	1.1%
27	1	1.1%

Messaging Conversations Started
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	32
Distinct (%)	46.4%
Missing	18
Missing (%)	20.7%
Infinite	0
Infinite (%)	0.0%
Mean	17.10144928

Minimum	1
Maximum	121
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	824.0 B

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	9
Q3	23
95-th percentile	53.2
Maximum	121
Range	120
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	20.5477528
Coefficient of variation (CV)	1.201521138
Kurtosis	8.878494335
Mean	17.10144928
Median Absolute Deviation (MAD)	7
Skewness	2.503211861
Sum	1180
Variance	422.2101449
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=32)

Value	Count	Frequency (%)
1	7	8.0%
3	6	6.9%
2	5	5.7%
5	4	4.6%
10	4	4.6%
8	4	4.6%
6	3	3.4%
9	3	3.4%
17	3	3.4%
29	2	2.3%
Other values (22)	28	32.2%
(Missing)	18	20.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	7	8.0%
2	5	5.7%
3	6	6.9%
4	2	2.3%
5	4	4.6%
6	3	3.4%
7	2	2.3%
8	4	4.6%
9	3	3.4%
10	4	4.6%

Value	Count	Frequency (%)
121	1	1.1%
65	1	1.1%
64	1	1.1%
56	1	1.1%
49	1	1.1%
43	2	2.3%
42	1	1.1%
41	1	1.1%
38	1	1.1%
36	2	2.3%

Frequency
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	79
Distinct (%)	90.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.170927552

Minimum	0
Maximum	2.213877
Zeros	8
Zeros (%)	9.2%
Negative	0
Negative (%)	0.0%
Memory size	824.0 B

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1.090525
median	1.212693
Q3	1.372782
95-th percentile	1.7404124
Maximum	2.213877
Range	2.213877
Interquartile range (IQR)	0.282257

Descriptive statistics

Standard deviation	0.4386805971
Coefficient of variation (CV)	0.3746436716
Kurtosis	2.845484436
Mean	1.170927552
Median Absolute Deviation (MAD)	0.154365
Skewness	-1.339504037
Sum	101.870697
Variance	0.1924406663
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	8	9.2%
1	2	2.3%
1.103567	1	1.1%
1.416992	1	1.1%
1.294536	1	1.1%
1.096291	1	1.1%
1.27367	1	1.1%
1.180587	1	1.1%
1.421704	1	1.1%
1.188254	1	1.1%
Other values (69)	69	79.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	8	9.2%
1	2	2.3%
1.006003	1	1.1%
1.006452	1	1.1%
1.021429	1	1.1%
1.022581	1	1.1%
1.026178	1	1.1%
1.028681	1	1.1%
1.033103	1	1.1%
1.035391	1	1.1%

Value	Count	Frequency (%)
2.213877	1	1.1%
2.020319	1	1.1%
1.974644	1	1.1%
1.76544	1	1.1%
1.764329	1	1.1%
1.684607	1	1.1%
1.644993	1	1.1%
1.625648	1	1.1%
1.549848	1	1.1%
1.548859	1	1.1%

CPC (All) (MXN)
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	79
Distinct (%)	90.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.048275046

Minimum	0
Maximum	10.7
Zeros	9
Zeros (%)	10.3%
Negative	0
Negative (%)	0.0%
Memory size	824.0 B

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.337426
median	0.682813
Q3	1.0735725
95-th percentile	2.4130448
Maximum	10.7
Range	10.7
Interquartile range (IQR)	0.7361465

Descriptive statistics

Standard deviation	1.699669893
Coefficient of variation (CV)	1.621396884
Kurtosis	20.92144389
Mean	1.048275046
Median Absolute Deviation (MAD)	0.366637
Skewness	4.398133444
Sum	91.199929
Variance	2.888877745
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	9	10.3%
0.500159	1	1.1%
1.248699	1	1.1%
0.830189	1	1.1%
0.557	1	1.1%
0.887941	1	1.1%
1.816979	1	1.1%
0.3125	1	1.1%
0.3925	1	1.1%
0.333279	1	1.1%
Other values (69)	69	79.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	9	10.3%
0.065317	1	1.1%
0.074238	1	1.1%
0.113662	1	1.1%
0.135714	1	1.1%
0.148368	1	1.1%
0.166771	1	1.1%
0.167179	1	1.1%
0.173624	1	1.1%
0.275962	1	1.1%

Value	Count	Frequency (%)
10.7	1	1.1%
9.620581	1	1.1%
7.709	1	1.1%
2.74902	1	1.1%
2.462105	1	1.1%
2.298571	1	1.1%
2.005257	1	1.1%
1.879412	1	1.1%
1.816979	1	1.1%
1.743889	1	1.1%

CTR (all)
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	79
Distinct (%)	90.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.988235609

Minimum	0
Maximum	18.461538
Zeros	9
Zeros (%)	10.3%
Negative	0
Negative (%)	0.0%
Memory size	824.0 B

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2.5359305
median	4.755245
Q3	6.1143855
95-th percentile	13.740369
Maximum	18.461538
Range	18.461538
Interquartile range (IQR)	3.578455

Descriptive statistics

Standard deviation	3.83244521
Coefficient of variation (CV)	0.7682967507
Kurtosis	2.798938627
Mean	4.988235609
Median Absolute Deviation (MAD)	1.698938
Skewness	1.435802975
Sum	433.976498
Variance	14.68763629
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	9	10.3%
3.915475	1	1.1%
4.238456	1	1.1%
5.016089	1	1.1%
5.855563	1	1.1%
6.017699	1	1.1%
1.932173	1	1.1%
10.505581	1	1.1%
9.52381	1	1.1%
5.842912	1	1.1%
Other values (69)	69	79.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	9	10.3%
0.255754	1	1.1%
0.840172	1	1.1%
1.033592	1	1.1%
1.217949	1	1.1%
1.46636	1	1.1%
1.811137	1	1.1%
1.932173	1	1.1%
2.037822	1	1.1%
2.21412	1	1.1%

Value	Count	Frequency (%)
18.461538	1	1.1%
16.734069	1	1.1%
16.419001	1	1.1%
15.429831	1	1.1%
14.894193	1	1.1%
11.048113	1	1.1%
10.505581	1	1.1%
10.055866	1	1.1%
9.52381	1	1.1%
8.744395	1	1.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	Campaign ID	Starts	Ends	Ad set budget	Results	Reach	Impressions	Cost per results	Amount spent (MXN)	Result rate	New messaging connections	Messaging Conversations Started	Frequency	CPC (All) (MXN)	CTR (all)
0	341	01	02	Using ad set budget	NaN	0	0	NaN	0.00	NaN	NaN	NaN	0.000000	0.000000	0.000000
1	995	01	02	Using ad set budget	NaN	0	0	NaN	0.00	NaN	NaN	NaN	0.000000	0.000000	0.000000
2	964	01	02	Using ad set budget	NaN	0	0	NaN	0.00	NaN	NaN	NaN	0.000000	0.000000	0.000000
3	849	02	02	Using ad set budget	NaN	0	0	NaN	0.00	NaN	NaN	NaN	0.000000	0.000000	0.000000
4	182	02	02	Using ad set budget	NaN	0	0	NaN	0.00	NaN	NaN	NaN	0.000000	0.000000	0.000000
5	663	02	02	Using ad set budget	2.0	0	0	0.000000	0.00	NaN	NaN	2.0	0.000000	0.000000	0.000000
6	928	03	03	Using ad set budget	15.0	2511	3072	5.560000	83.40	0.488281	9.0	15.0	1.223417	0.538065	5.045573
7	264	03	03	Using ad set budget	8.0	1408	1656	7.470000	59.76	0.483092	8.0	8.0	1.176136	0.429928	8.393720
8	465	03	03	Using ad set budget	36.0	13358	17480	12.796667	460.68	0.205950	29.0	36.0	1.308579	0.543255	4.851259
9	816	03	04	Using ad set budget	17.0	4203	5906	15.742353	267.62	0.287843	13.0	17.0	1.405187	0.803664	5.638334

Last rows

	Campaign ID	Starts	Ends	Ad set budget	Results	Reach	Impressions	Cost per results	Amount spent (MXN)	Result rate	New messaging connections	Messaging Conversations Started	Frequency	CPC (All) (MXN)	CTR (all)
77	416	11	11	1000	NaN	620	634	NaN	26.49	NaN	NaN	NaN	1.022581	0.735833	5.678233
78	625	11	11	500	22.0	5454	7719	22.727273	500.00	0.285011	22.0	22.0	1.415292	0.959693	6.749579
79	135	11	11	500	30.0	7150	9205	16.666667	500.00	0.325910	26.0	30.0	1.287413	1.016260	5.344921
80	869	11	11	160	NaN	1120	1345	NaN	50.25	NaN	NaN	NaN	1.200893	0.810484	4.609665
81	465	11	11	500	6.0	3657	5404	57.548333	345.29	0.111029	6.0	6.0	1.477714	1.743889	3.663953
82	772	11	11	300	NaN	191	196	NaN	16.57	NaN	NaN	NaN	1.026178	1.380833	6.122449
83	126	01	01	200	10.0	2435	3548	16.065000	160.65	0.281849	10.0	10.0	1.457084	0.823846	5.496054
84	499	01	01	300	8.0	2894	3970	25.201250	201.61	0.201511	8.0	8.0	1.371804	0.908153	5.591940
85	548	01	01	300	13.0	3285	3920	17.327692	225.26	0.331633	NaN	13.0	1.193303	2.298571	2.500000
86	531	03	03	500	26.0	8124	9842	11.015385	286.40	0.264174	21.0	26.0	1.211472	0.569384	5.110750

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows